Data Dictionary
SKU Import Template
Overview
The SKU Import Template is a user-friendly feature that facilitates the effortless import of SKU (Stock Keeping Unit) information. Users can efficiently manage product data by entering details such as SKUID, transaction type code, reasons for SKU changes, effective start and end dates, state and country codes, cost center, general ledger account, material group, parameters, regulatory codes, tax types, and customer types. This template streamlines the process of updating and categorizing SKU details, ensuring accurate and comprehensive product information within the sales tax system. Users can easily navigate through the fields, set effective dates, and provide reasons, enabling a seamless and efficient import process for SKU data management.
Download Template: SKU Import Template
File Type: csv
Detail Record
The record below shows the various fields within the record. Each field is linked within the data dictionary which provides additional information including field constraints as well as allowed values.
| Display Name | Field Name | Field Type |
|---|---|---|
| SKUID | SKUID | string |
| Transaction Type Code | TransTypeCode | string |
| Reason | Reason | string |
| Start Effective Date | StartEffectiveDate | date |
| End Effective Date | EndEffectiveDate | date |
| State Code | StateCode | string |
| Country Code | CountryCode | string |
| Cost Center | CostCenter | string |
| General Ledger Account | GLAccount | string |
| Material Group | MaterialGroup | string |
| Parameter 1 | Parameter1 | string |
| Regulatory Code | RegulatoryCode | string |
| Tax Type | TaxType | string |
| Customer Type | CustomerType | CustomerType |